UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0a1s0NapBXQjBSATLfdyi7wBoPASi32KjWVMWKXgp1o='
WHERE
key_id = '9d0dc484e2ac1c5254984ee3c8afd22b1aa992168a8c6b73ce3e5154c12d0cff'
AND (
token = '0a1s0NapBXQjBSATLfdyi7wBoPASi32KjWVMWKXgp1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)