UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fTShZMgzBYU2aXnxZlCslNy3McOKve/2pjWM2DPfOQ8='
WHERE
key_id = '92024835a3747ff57b6a4ab823e82b51ba2463917577f9d7764f41ad49c20e88'
AND (
token = 'fTShZMgzBYU2aXnxZlCslNy3McOKve/2pjWM2DPfOQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)