UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8doqNNpwA/F6aUDM5AdnY10fG6BT3d4bVxnLUfVTjhA='
WHERE
key_id = '7f54aec18f9cf4821a35ad88d621be0e49de1d94f6af88f85a2943c00047b717'
AND (
token = '8doqNNpwA/F6aUDM5AdnY10fG6BT3d4bVxnLUfVTjhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)