UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpqCq5IFRZRgQLc/ka9Cggme2tJIK/N+dEwQpcNBr20='
WHERE
key_id = 'bbc0e1102edd2927ec7d9d277a91e1cc7399898235e2e712b79490b5dc3f753d'
AND (
token = 'XpqCq5IFRZRgQLc/ka9Cggme2tJIK/N+dEwQpcNBr20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)