UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFCjXirmUy5o1I+diLiu0L6SlOa47Jo6E6ES3aANQ3A='
WHERE
key_id = '6c1b3c4a8544fc67d4f67622daee899e32fa6f8107a5cc58fcebcb96a3a8d20f'
AND (
token = 'TFCjXirmUy5o1I+diLiu0L6SlOa47Jo6E6ES3aANQ3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)