UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K59J6R9bcvN9ZSABENEpQVrInnB374RNeWTvIk6A1Us='
WHERE
key_id = 'f9c2cdbc7b7419bb0565e458c44783c35dff032a4edaf497e43252b38fa5b7ad'
AND (
token = 'K59J6R9bcvN9ZSABENEpQVrInnB374RNeWTvIk6A1Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)