UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nx0GJ7RDz+Q3PmrHPjfv46cgQAviq4MlCbUtY69jqkY='
WHERE
key_id = '5fbc837a92334555e5a80604858372e5cc2e2f79c6bafcb5fc2052110514850a'
AND (
token = 'nx0GJ7RDz+Q3PmrHPjfv46cgQAviq4MlCbUtY69jqkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)