UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WogTgtq9w6cQ1JMMpNBW6iyRY6Rfz5WIWkf7z7pUzRw='
WHERE
key_id = 'ef9cc2f76438f17285a5e136ed642ba26ac8819865b048945f24382e92e092d9'
AND (
token = 'WogTgtq9w6cQ1JMMpNBW6iyRY6Rfz5WIWkf7z7pUzRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)