UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPfTxR1JHAML1TweBUc5eyXgqpgOPg1I+BBQy2xuzoM='
WHERE
key_id = '640b761745357fb5a6e8532d9b515a6a1c71976e0e5794d241112d348abd71bf'
AND (
token = 'tPfTxR1JHAML1TweBUc5eyXgqpgOPg1I+BBQy2xuzoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)