UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fpoJR8NBMrLyffDDa99pf9BBesIW/WaKXwDApS/Hlc='
WHERE
key_id = '1e32efb4595b9d35c5719e12738b1c2d5648320101f161667e5c3fa59e90b337'
AND (
token = '9fpoJR8NBMrLyffDDa99pf9BBesIW/WaKXwDApS/Hlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)