UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0Z8T3tTIO9Y6wKYnixnCgrC3qsK/ZeHFktYxF9TcV8='
WHERE
key_id = 'de78889476ec3868e248a6e5013c186b46a53ea0d96ee6f2f65c5e1f8f89c69d'
AND (
token = 'm0Z8T3tTIO9Y6wKYnixnCgrC3qsK/ZeHFktYxF9TcV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)