UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sU8lGiT0gU6bK8UMJj8MPAMLM45CpnRLBKkok2OQZzY='
WHERE
key_id = '1771d12ce80b13b00d901c5e916f4006e9a9761253473d348151d6ccb62df069'
AND (
token = 'sU8lGiT0gU6bK8UMJj8MPAMLM45CpnRLBKkok2OQZzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)