UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zIz3p/xPOluCg1LSW/9QcjEli+3bAO0YXbCOV44m1x0='
WHERE
key_id = '6381b6f7c714f4f16d0905781cade353dda3d78a7f41788efb3bb7ba833e6b52'
AND (
token = 'zIz3p/xPOluCg1LSW/9QcjEli+3bAO0YXbCOV44m1x0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)