UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PLI3+/s9is7ZBUpW8gJ0kyEMNMFm2n5JR9MwI5nZ1k0='
WHERE
key_id = '0ffd4c9fb75208fc7bba925437d2e94112a4417e028625d01cc4f3e9c4c09384'
AND (
token = 'PLI3+/s9is7ZBUpW8gJ0kyEMNMFm2n5JR9MwI5nZ1k0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)