UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hTw0O3oSv4wtkCTZsdMV8blj8fzh4SW9tgmOmj938c0='
WHERE
key_id = '3d29c74c2dc779068a493a63ae7f6dc956b2f30f8a8ef760a3c5f9594a9c6b69'
AND (
token = 'hTw0O3oSv4wtkCTZsdMV8blj8fzh4SW9tgmOmj938c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)