UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmMzSZtlk5g8nC/HLgIthpEbg59PCfkEBfjyFj2dy/s='
WHERE
key_id = 'b113c7714b3ec340cebd127ab5f7e42fc848f4846961e05d26e259bd4bfdfa80'
AND (
token = 'NmMzSZtlk5g8nC/HLgIthpEbg59PCfkEBfjyFj2dy/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)