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