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