UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKdKZI2pCDZoWehAIzshJBfk9cDC4Uyb67m6n8LuuLM='
WHERE
key_id = '579318ed17b55657f154ffd60ac3bdf04c46627f807cf65cf7ecf6645ba64b6a'
AND (
token = 'CKdKZI2pCDZoWehAIzshJBfk9cDC4Uyb67m6n8LuuLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)