UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jgn/Miwc9KxVtLEClzqbVgvWMFyP6hB989N80M4bElA='
WHERE
key_id = 'd9349b2d693558f87fe227d5a5348789bbea9da3e56402ac8244aea24376fea2'
AND (
token = 'Jgn/Miwc9KxVtLEClzqbVgvWMFyP6hB989N80M4bElA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)