UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'On0FNp49/NeaYqA3aAo41kOaJRzf51lHtUHW6C63Bx8='
WHERE
key_id = 'aa8f5d044dac7c52ae3ad35c0cc4a571656117e46ab11ec00713e975f7629e9f'
AND (
token = 'On0FNp49/NeaYqA3aAo41kOaJRzf51lHtUHW6C63Bx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)