UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sk3gy5ODEWU8Tog383QulFsXz22uZ+ag/SA5HjwjaI='
WHERE
key_id = '0f8522af789d4c5ca5217b329cf0269bc0218e96688a88b7eeb55731f782f3fc'
AND (
token = '9sk3gy5ODEWU8Tog383QulFsXz22uZ+ag/SA5HjwjaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)