UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QHXvm73jX1eZng8S8t/2+X6O5aYm8u6dkkNawYuaFs='
WHERE
key_id = 'f69c3fe233e7e5a953e8dd87705f767f06763dfe2cbad80c9e14679f57058ee4'
AND (
token = '/QHXvm73jX1eZng8S8t/2+X6O5aYm8u6dkkNawYuaFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)