UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NWugX8zcbq6rUXZUXjS7Io8IGg5kS4vl4/TPm2CzXW0='
WHERE
key_id = 'e1674c235cc46db731a5944bc4f85b0eaa0bd9434b866f62b20f496a27153a18'
AND (
token = 'NWugX8zcbq6rUXZUXjS7Io8IGg5kS4vl4/TPm2CzXW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)