UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XAyLWiHJ5+tRObZ3b6wQJ/5NSGmBypk0voyKgym+CE='
WHERE
key_id = '9b50bbc767f39f245483527aab8f610b126c446e78eae1f7b59ac66c0a21599a'
AND (
token = '/XAyLWiHJ5+tRObZ3b6wQJ/5NSGmBypk0voyKgym+CE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)