UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4h4ZsPlNVvWKM8HmmyCwd0UEBN4yjZ8Pn6TnIZpd7y4='
WHERE
key_id = '231e473b955db16dbc5f82b1e20fb0de8295cbac376413d9289ffe749ea8dfe5'
AND (
token = '4h4ZsPlNVvWKM8HmmyCwd0UEBN4yjZ8Pn6TnIZpd7y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)