UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kHDD8nw31OLAbz8NDJiofQ7zqASdBawnAfeN88Qjqg='
WHERE
key_id = '8fc9c49765de5eb3e81b16158c73d3a554261606d3205af6fd8dfe8cb3e9d56f'
AND (
token = '0kHDD8nw31OLAbz8NDJiofQ7zqASdBawnAfeN88Qjqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)