UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiXXvl0YG+EuST92tRDAK+PMvQ3dB9h2cW0+AYrDrco='
WHERE
key_id = 'e126e18fa20f5a2832fd1eac61cfc60ecd0bf43ccb133836252432fbbc2e1f1b'
AND (
token = 'ZiXXvl0YG+EuST92tRDAK+PMvQ3dB9h2cW0+AYrDrco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)