UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9RP7fepDZLZfaNzuzxKFLPOrlic+uuuPAXDK+s//rE='
WHERE
key_id = '9d807ca79cb1a2791db92e7826522dbe00bf3e30802be7790465b9f099a46543'
AND (
token = 'z9RP7fepDZLZfaNzuzxKFLPOrlic+uuuPAXDK+s//rE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)