UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'an4yC95Cy0wdxCYlz3akgGiUhELZYDqIghdSvo1/JCI='
WHERE
key_id = '156a57e4e9d1eec52a9d970ed2970e20c545aaa4af0e0d32e5daa28a5bb1a397'
AND (
token = 'an4yC95Cy0wdxCYlz3akgGiUhELZYDqIghdSvo1/JCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)