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