UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oVMLz0uhygK1BpwOQoTOB4U9P/knxC6YyAnngZKYUs='
WHERE
key_id = '99430bec14e7cbd6811139e83706d2e183d67b36850505c2a0401efe5bee474f'
AND (
token = '9oVMLz0uhygK1BpwOQoTOB4U9P/knxC6YyAnngZKYUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)