UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bBqeh68cNynkekFkpwZbReiCvc3aGwCptNLkua7/8B4='
WHERE
key_id = '401fc7a69ae56a23f874f8f8a4269fd832ad4203d15323aafdd61df33c171af8'
AND (
token = 'bBqeh68cNynkekFkpwZbReiCvc3aGwCptNLkua7/8B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)