UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VMJenpmITiGH0pSOVo94FnCD9CTUIy7TpizmeO7FKu8='
WHERE
key_id = '47a9692e3655c07b5d07957973ea954e40b008bfb162c75b1a04e2c9fd1b79a1'
AND (
token = 'VMJenpmITiGH0pSOVo94FnCD9CTUIy7TpizmeO7FKu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)