UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fP++0cp2FOtLLQrosdUogt3QOlVE9Ett/7DvEqT6CY8='
WHERE
key_id = 'd767cfe7a99ff819ee88892bd124651179b7bdd0d546254be197675e531a57e5'
AND (
token = 'fP++0cp2FOtLLQrosdUogt3QOlVE9Ett/7DvEqT6CY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)